MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

14 rows where Object Name = 6099

View and edit SQL

Suggested facets: Title, Culture, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
70199 C.I.49.37.44 0 0 84058 Costume Institute 8 Sundress 6099 Sundress American 1         Designer|Manufacturer 3   Claire McCardell|Townley Frocks American, 1905–1958|American, founded 1929   McCardell Claire|Townley 5280 American|American 5 1905 |1929 1958 1943 1943 1943 cotton 3340   Gift of Claire McCardell, 1949                           Metropolitan Museum of Art, New York, NY 1
70751 1980.584.1 0 0 84791 Costume Institute 8 Sundress 6099 Sundress American 1         Designer 5   Valentina American, born Russia, 1899–1989   Valentina 5269 American 1 1899 1989 1936–38 1936 1938 flax, cotton 16201   Gift of Jane M. Bingham, 1980                           Metropolitan Museum of Art, New York, NY 1
74167 1993.224 0 0 94280 Costume Institute 8 Sundress 6099 Sundress American 1         Designer|Department Store 205   Anne Fogarty|Saks Fifth Avenue American, Pittsburgh, Pennsylvania 1919–1980 New York|American, founded 1924   Fogarty, Anne|Saks Fifth Avenue 6180 American|American 5 1919 |1924 1980 |9999 ca. 1953 1948 1958 cotton 3340   Anonymous Gift, 1993                           Metropolitan Museum of Art, New York, NY 1
74443 C.I.65.33.13 0 0 94815 Costume Institute 8 Sundress 6099 Sundress French 7         Designer|Design House 202   Yves Saint Laurent|House of Dior French (born Algeria) Oran 1936–2008 Paris|French, founded 1947   Saint Laurent Yves|Dior, House of 5455 French|French 21 1936 |1947 2008 |9999 ca. 1959 1957 1964 cotton 3340   Gift of Mrs. Henry Rogers Benjamin, 1965                           Metropolitan Museum of Art, New York, NY 1
75521 C.I.65.33.21a, b 0 0 96942 Costume Institute 8 Sundress 6099 Sundress French 7         Designer 5   Elsa Schiaparelli Italian, 1890–1973   Schiaparelli Elsa 5266 Italian 6 1890 1973 1948–49 1948 1949 rayon, cotton 15873   Gift of Mrs. Henry Rogers Benjamin, 1965                           Metropolitan Museum of Art, New York, NY 1
75881 C.I.49.37.29 0 0 97485 Costume Institute 8 Sundress 6099 Sundress American 1         Designer|Manufacturer 3   Claire McCardell|Townley Frocks American, 1905–1958|American, founded 1929   McCardell Claire|Townley 5280 American|American 5 1905 |1929 1958 1944 1944 1944 cotton 3340   Gift of Claire McCardell, 1949                           Metropolitan Museum of Art, New York, NY 1
75882 C.I.49.37.43 0 0 97486 Costume Institute 8 Sundress 6099 Sundress American 1         Designer|Manufacturer 3   Claire McCardell|Townley Frocks American, 1905–1958|American, founded 1929   McCardell Claire|Townley 5280 American|American 5 1905 |1929 1958 1943 1943 1943 cotton 3340   Gift of Claire McCardell, 1949                           Metropolitan Museum of Art, New York, NY 1
78153 C.I.69.22.1 0 0 103577 Costume Institute 8 Sundress 6099 Sundress French 7                           1967 1967 1967 cotton 3340   Gift of Ellen Berthe Hermanos, 1969                           Metropolitan Museum of Art, New York, NY 1
90161 2009.300.145 0 0 156166 Costume Institute 8 Sundress 6099 Sundress American 1         Manufacturer|Designer 18 Textile manufactured by ABC Fabrics|Carolyn Schnurer American, born New York, 1908–1998 Palm Beach, Florida   ABC Fabrics|Schnurer Carolyn 6957   1908 1998 1950 1950 1950 cotton 3340   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Carolyn Schnurer, 1951                           Metropolitan Museum of Art, New York, NY 1
90326 2009.300.159a, b 0 0 156331 Costume Institute 8 Sundress 6099 Sundress American 1         Designer|Manufacturer 3 Textile manufactured by Carolyn Schnurer|Arthur Bier and Co. Inc. American, born New York, 1908–1998 Palm Beach, Florida   Schnurer Carolyn|Bier and Co. Inc. Arthur 6998   1908 1998 1952 1952 1952 cotton 3340   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Carolyn Schnurer, 1952                           Metropolitan Museum of Art, New York, NY 1
91096 2009.300.230 0 0 157111 Costume Institute 8 Sundress 6099 Sundress American 1         Manufacturer|Designer 18   Townley Frocks|Claire McCardell American, founded 1929|American, 1905–1958   Townley|McCardell Claire 6309 American|American 5 1929 |1905 1958 1945 1945 1945 cotton 3340   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Claire McCardell, 1956                           Metropolitan Museum of Art, New York, NY 1
92008 2009.300.3141 0 0 158045 Costume Institute 8 Sundress 6099 "The Hakama Dress" American 1         Manufacturer|Designer 18 Textile manufactured by Springmaid|Carolyn Schnurer American|American, born New York, 1908–1998 Palm Beach, Florida   Springmaid|Schnurer Carolyn 7002 American 1 1908 1998 1952 1952 1952 cotton 3340   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Carolyn Schnurer, 1952                           Metropolitan Museum of Art, New York, NY 1
96748 2009.300.6984 0 0 173982 Costume Institute 8 Sundress 6099 Sundress American 1         Manufacturer|Designer 18   Townley Frocks|Claire McCardell American, founded 1929|American, 1905–1958   Townley|McCardell Claire 6309 American|American 5 1929 |1905 1958 1952 1952 1952 Cotton 2154   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Claire McCardell, 1956                           Metropolitan Museum of Art, New York, NY 1
98245 2009.300.6978a, b 0 0 175700 Costume Institute 8 Sundress 6099 Sundress American 1         Designer 5   Claire McCardell American, 1905–1958   McCardell Claire 5437 American 1 1905 1958 1946 1946 1946 Cotton 2154   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Claire McCardell, 1956                           Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 158.443ms · Data license: CC0 · Data source: metmuseum/openaccess